package com.cf.mapper;

import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CheckAttendanceMapper {

	@Select("select name,department,classify,checkDate,weekDay,allTime,caHour,overHour, "
			+ "late,earlier,less,needCheck,notAttendance "
			+ "from CharlieCaSumCheck "
			+ "where cast(checkDate as datetime) between #{startDate} and #{endDate} "
			+ "and name like '%'+#{name}+'%' ")
	List<LinkedHashMap<String, Object>> listCA(Date startDate, Date endDate,
			String name);

}
